| SaCC |
| Logical Entity Name | SaCC |
| Default Table Name | SaCC |
| Physical Only | NO |
| Owner | dbo |
| Definition | |
| Note |
| SaCC Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
SaCcID |
int | NO | ||
| SyStudentID | int | NO | ||
| Number | varchar(120) | NO | ||
| Expire | datetime | NO | ||
| CardHolderName | varchar(50) | NO | ||
| CardHolderAddr | varchar(50) | YES | ||
| CardHolderZip | varchar(15) | YES | ||
| DateAdded | datetime | NO | ||
| DateLstMod | datetime | NO | ||
| UserID | int | NO | ||
| ts | timestamp | NO | ||
| SaCCTypeID | int | YES | ||
| LastFourNumber | char(4) | YES | ||
| VerificationNumber | char(4) | YES | ||
| AptNumber | char(10) | YES | ||
| CardHolderCity | varchar(30) | YES | ||
| CardHolderState | char(2) | YES | ||
| PrimaryPayment | bit | NO | ||
| active | bit | NO | ||
| VerifyFlag | bit | NO | ||
| DefaultCC | bit | NO | ||
| CardHolderFirstname | varchar(50) | NO | ||
| CardHolderLastname | varchar(50) | NO | ||
| MerchantProcessingCode | varchar(19) | YES | ||
| IsCCNumStored | bit | NO | ||
| CCGuid | varchar(32) | YES | ||
| CCAuthNum | nchar(14) | YES | ||
| CoRelationId | nvarchar(20) | YES | ||
| PaymentGatewayProvider | nchar(30) | YES | ||
| IsSingleUse | bit | NO |
| SaCC Primary and Unique Keys |
| Key Name | Key Type | Keys |
| SaCC_SaCcID_U_C_IDX | PrimaryKey | SaCcID |
| SaCC Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication |
| Child Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication |
| AmApplicant | Non-Identifying | One To Zero or More | FK_AmApplicant_SaCCID_SaCC_SaCCID | NO | YES | |||
| FaRefund | Non-Identifying | One To Zero or More | FK_FaRefund_SaCCID_SaCC_SaCCID | NO | YES | |||
| FaStudentAid | Non-Identifying | One To Zero or More | FK_FaStudentAid_SaCcId_SaCc_SaCcId | NO | YES | |||
| SaCreditCardBatchRefund | Non-Identifying | One To Zero or More | FK_SaCreditCardBatchRefund_SaCCID_SaCC_SaCCID | NO | YES | |||
| SaStudSubsidiaryTrans | Non-Identifying | One To Zero or More | Fk_SaStudSubsidiaryTrans_SaCCID_SaCC_SaCCID | NO | YES |
| SaCC Check Constraints |
| Check Constraint Name | CheckConstraint |
| SaCC Storage |
| STORAGE OPTION | STORAGE VALUE |
| Filegroup | PRIMARY |
| Text Image File Group |
| SaCC Where Used - Model Usage |
| Mapped Object | Is User Defined? | Denormalization Mappings | Description | Bound Attachments |
| Logical dbo.StudentCreditCard |
NO | |||
| Physical (Microsoft SQL Server) dbo.SaCC |
NO |
| SaCC Where Used - Submodel Usage |
| Model | Submodel Usage |
| Logical | Main Model |
| Logical | ElectronicPaymentProcessing |
| Logical | LedgerCard_Billing |
| Logical | Refunds_Stipends |
| Logical | StudentPayments_Collections |
| Logical | SubsidiaryLedger |
| Physical (Microsoft SQL Server) | Main Model |
| Physical (Microsoft SQL Server) | Student Accounts |
| SaCC Data Movement Rules |
| Name | Type | Rule Text/Value |